const {Controller} = require('egg');

class HomeController extends Controller {
	async getArticleList() {
		let sql =
			"SELECT article.id as id,article.title as title,article.introduce as introduce," +
			"FROM_UNIXTIME(article.addTime, '%Y-%m-%d %H:%i:%s') as addTime,article.view_count as view_count,type.typeName as typeName FROM article LEFT JOIN type ON article.type_id = type.Id"

		const results = await this.app.mysql.query(sql)

		this.ctx.body = {
			data: results
		}
	}

	async getArticleById() {
		let id = this.ctx.params.id
		let sql = 'SELECT article.id as id ,' +
			'article.title as title ,' +
			'article.introduce as introduce ,' +
			'article.article_content as article_content ,' +
			"FROM_UNIXTIME(article.addTime,'%Y-%m-%d %H:%i:%s' ) as addTime ," +
			'article.view_count as view_count ,' +
			'type.typeName as typeName ,' +
			'type.id as typeId ' +
			'FROM article LEFT JOIN type ON article.type_id = type.Id ' +
			'WHERE article.id=' + id

		const result = await this.app.mysql.query(sql)

		this.ctx.body = {data: result}
	}

	async getTypeInfo() {
		const result = await this.app.mysql.select('type')
		this.ctx.body = {data: result}
	}

	// 根据类别获取文章列表
	async getListById() {
		let id = parseInt(this.ctx.params.id)
		if (id) {
			let sql = 'SELECT article.id as id,' +
				'article.title as title,' +
				'article.introduce as introduce,' +
				"FROM_UNIXTIME(article.addTime,'%Y-%m-%d %H:%i:%s' ) as addTime," +
				'article.view_count as view_count ,' +
				'type.typeName as typeName ' +
				'FROM article LEFT JOIN type ON article.type_id = type.Id ' +
				'WHERE type_id=' + id
			const result = await this.app.mysql.query(sql)
			this.ctx.body = {data: result}
		} else {
			this.ctx.body = {data: '错误的Id'}
		}
	}

}

module.exports = HomeController